UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rGFTloO9PlJjqZLi+Xw6BzwsC9ifCk01zND7TiLbTJY=' 
WHERE 
  key_id = '05bf6ca9b9dfafae9648b01a5c59845070b6d17f7cad3cad1d81b52aeeaf9693' 
  AND (
    token = 'rGFTloO9PlJjqZLi+Xw6BzwsC9ifCk01zND7TiLbTJY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046