UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4V/+1SEJ9R+ZSiHnzru5XgXBzYGHXJQeA5CRCwZ6aYA='
WHERE
key_id = '7ef13eae03115371031de6b761eaa1d6e1de4fadc55ef0dbf6cb1bc06a2187b1'
AND (
token = '4V/+1SEJ9R+ZSiHnzru5XgXBzYGHXJQeA5CRCwZ6aYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)