UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMZ7umtZnxm9V84j8W3WsiLouDtA8oJt5HGyzZFGNj8='
WHERE
key_id = 'ac57bfd133f4809895444a2c5f2b0ea998b220237deefb7ef5d274f156ee9a17'
AND (
token = 'nMZ7umtZnxm9V84j8W3WsiLouDtA8oJt5HGyzZFGNj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)