UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MYXKsmpZZYnyYNNS2dwm0jHBZzKOYy9lG1qI/LUWGc='
WHERE
key_id = '0836fe2922c5c85675d9a931c99fb0ab0c72053754ff17c89e2697a431bf8147'
AND (
token = '8MYXKsmpZZYnyYNNS2dwm0jHBZzKOYy9lG1qI/LUWGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)