UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WjD6giWkr6IBhcEZmtdqXOIEEeDYjkQ766E9CheOKOw='
WHERE
key_id = '9ad1adaee446b54a08fbfe9f8376e60ab41b1f909b08659f9f511f8df49b1d4f'
AND (
token = 'WjD6giWkr6IBhcEZmtdqXOIEEeDYjkQ766E9CheOKOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)