UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1m92uiMwAlA5N/5shzaKb9O/1eQRUNzcdHiuJ/A1WE='
WHERE
key_id = 'f197dcc5ff0c8bbcf9e16f450461f24dff7f0a18c40438fd5ca7b3ed8bbea74d'
AND (
token = 'V1m92uiMwAlA5N/5shzaKb9O/1eQRUNzcdHiuJ/A1WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)