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