UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNHplI0JvcbYnIHxkYwvQz/+IZPUj8S1XiyvEKYGix4='
WHERE
key_id = 'edf344f2b89d619743208779eb83685d8fc597f023c0c37d29dedbcade1808ab'
AND (
token = 'TNHplI0JvcbYnIHxkYwvQz/+IZPUj8S1XiyvEKYGix4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)