UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rq/XqBvem2QkVrju+zi2txAvdCC5Cs3TkNlsxQz3DyY=' 
WHERE 
  key_id = 'c4384c95ee01d9d434b22faf8aa369100f58b8098b9ea59936951a824a956928' 
  AND (
    token = 'rq/XqBvem2QkVrju+zi2txAvdCC5Cs3TkNlsxQz3DyY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034