UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BDQ2PRM41oaDxvRQQ/ErEQUocTSRrm/Kx6i55wN2vFw=' 
WHERE 
  key_id = '581519085a7019eff316c91936ce10f3cd27cc189f8fc20903a6f71e65bed4b9' 
  AND (
    token = 'BDQ2PRM41oaDxvRQQ/ErEQUocTSRrm/Kx6i55wN2vFw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053