UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7+7QqEF7sXb6GHyS07+rkDEk8n02RPMbyS32WaSyy0='
WHERE
key_id = '7c9a9aed62ed08ef3922c3e9ce114e4427e7060d9669e10844f88883d08be4a8'
AND (
token = 'l7+7QqEF7sXb6GHyS07+rkDEk8n02RPMbyS32WaSyy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)