UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oWrY5D3KQ/0FjrrWw7bur2GVEwG4Ct7LYJcnnsLdsNA=' 
WHERE 
  key_id = '418f0c879bba081d78de498c447f0786144e1703a5e3a280e226c7daa5c686de' 
  AND (
    token = 'oWrY5D3KQ/0FjrrWw7bur2GVEwG4Ct7LYJcnnsLdsNA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041