UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FPjbMq3McB1whHSEirEtm8I+aRvapAcYZ+jP7jmT6aw='
WHERE
key_id = '16585e9c20ea8ba3694439f24c9ccde02c8cefce42fa283e972ba7551c5a6cba'
AND (
token = 'FPjbMq3McB1whHSEirEtm8I+aRvapAcYZ+jP7jmT6aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)