UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BG0RSQy6P4ry2MIxy66y57m8kSqB5GHMxgIKVT9We4='
WHERE
key_id = 'afe2db442addb33ed39ee761b3eef7ea9db01d995aa0b0eb01b8fda33282efe8'
AND (
token = '7BG0RSQy6P4ry2MIxy66y57m8kSqB5GHMxgIKVT9We4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)