UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2MpVCEFhHqqhCdCgGCVs50CD9oYm0Pr0KN0BaUVuI+U='
WHERE
key_id = 'a2bc516063932586f662341b1f6b6afa3278607ef88593a03f7e1d0e23aeaa4e'
AND (
token = '2MpVCEFhHqqhCdCgGCVs50CD9oYm0Pr0KN0BaUVuI+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)