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