UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T7NXPO52zsOC9Oj21iu7qZM8P3XmaUINYSvKZVDm20s='
WHERE
key_id = '3046888ea6713d88b74581756bca3236b1ac45a451afe53b32a718401a3a7a78'
AND (
token = 'T7NXPO52zsOC9Oj21iu7qZM8P3XmaUINYSvKZVDm20s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)