UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L2n3OALTYkfWGtTG9fSu68ZU6hOV0vmgzxLUOVkusb8='
WHERE
key_id = 'c0a4d67824dc558924e9132040ca6441e37f009900526254b8a42ddb49bef651'
AND (
token = 'L2n3OALTYkfWGtTG9fSu68ZU6hOV0vmgzxLUOVkusb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)