UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1ipH0QPMiWo52PN+3/97NfLN0qjxPb6SnKp17tGtCpI=' 
WHERE 
  key_id = 'be7afe6474d8dc3fa423880b37bad2bbbefdb9fea5d3ec05144680af8d5d869c' 
  AND (
    token = '1ipH0QPMiWo52PN+3/97NfLN0qjxPb6SnKp17tGtCpI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044