UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iiT73PhgxbnMJM7fUcT2Za59bVVJ5A0OGTJvWsfu6r4='
WHERE
key_id = '8ae7b0ae7339d5c6d69e709939cf27770d0c712ad6cfda6d8b0924f488c6d5f5'
AND (
token = 'iiT73PhgxbnMJM7fUcT2Za59bVVJ5A0OGTJvWsfu6r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)