UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r5mqkGIITFljS+cAcsz8yoa6ONvnZ0v36/Y1exXcmlQ=' 
WHERE 
  key_id = 'b41cfb6a753d46d434a6e62521c513cbc56484a4337e8fe4f79d53303b2a8d33' 
  AND (
    token = 'r5mqkGIITFljS+cAcsz8yoa6ONvnZ0v36/Y1exXcmlQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021