UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OxJTZVNuL87FzUJSJGZd4ZhdnCHZr2UF/0qgykgZYSs='
WHERE
key_id = 'a990480855333f6bed902d34d57998d97adf83d5cd89ee932aff5edd363f72d0'
AND (
token = 'OxJTZVNuL87FzUJSJGZd4ZhdnCHZr2UF/0qgykgZYSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)