UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IiHjF7tWVyMk2JibGyr/vuOXq1uqVfJ0bEsr1bxJwzw='
WHERE
key_id = 'fbbf9a7e21cef4e7e4b5e0d89a30765a9678f108ef0de6ad67d1b9a925f3d2b0'
AND (
token = 'IiHjF7tWVyMk2JibGyr/vuOXq1uqVfJ0bEsr1bxJwzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)