UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l/ttuy/4VfAnbI4l3IvP0uawbxg9x5wjEICio9Xz974='
WHERE
key_id = '0a553492e03b975a13000bc23dcb8d6bd42194d339e638e7bbc5c5c93095b1bb'
AND (
token = 'l/ttuy/4VfAnbI4l3IvP0uawbxg9x5wjEICio9Xz974='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)