UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Det3Go7ORhmT9iScb2xcyYFOELVQS8C5D2nibGBrjsQ=' 
WHERE 
  key_id = '06b0baf7f5474ae3e2889bcceeb0a2b6fb86f53dc346054596dbfc134ad355d1' 
  AND (
    token = 'Det3Go7ORhmT9iScb2xcyYFOELVQS8C5D2nibGBrjsQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022