UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mpXEwJcmNBUnYv6FKpr8a7q97zHMRONJYR3SAgTNBtk=' 
WHERE 
  key_id = '9192941c86df01be8d9e8e9c8b2ef763eb5dcbd6da4fd4109e23d2cdba26de17' 
  AND (
    token = 'mpXEwJcmNBUnYv6FKpr8a7q97zHMRONJYR3SAgTNBtk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022