UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n0dVWjiSXYBHdVnyPQ8VEG6qSMpOvBzSEhkSsaS4gAg='
WHERE
key_id = 'd173257cb1fff6142abb93a08c9043f5e75df089013e4a7151dd967d0bd64035'
AND (
token = 'n0dVWjiSXYBHdVnyPQ8VEG6qSMpOvBzSEhkSsaS4gAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)