UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6Rf3b8aSszU7lPOO5z1tkFcMrXfiTaC0GP7sYf7n6M='
WHERE
key_id = '55cecaa4c0a99ce65bd95f2a4ea9126309d21400d61b28bf9a332d74a7b9a362'
AND (
token = 'K6Rf3b8aSszU7lPOO5z1tkFcMrXfiTaC0GP7sYf7n6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)