UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tz+ZTM3WPYDSOfgmpRtwvswIbynouWJgJzk6cAYTJ2I=' 
WHERE 
  key_id = 'd7177fadd2d6094d35e1e431e0b73df14d80f7520d5c9468bd2e5881d6aa99c6' 
  AND (
    token = 'tz+ZTM3WPYDSOfgmpRtwvswIbynouWJgJzk6cAYTJ2I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028