UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8DkWabJvRfjAPQMhOSnwtMIxn2tbtF7Pg3KoiIwky0='
WHERE
key_id = '9afa5c32ab471a4bc22b6e873e4f11821967852dee623406282a152eb91e13dd'
AND (
token = 'X8DkWabJvRfjAPQMhOSnwtMIxn2tbtF7Pg3KoiIwky0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)